package com.health.db.model;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PatientListExample   implements Serializable{
    /**
	 * 
	 */
	private static final long serialVersionUID = 6186753355884980947L;

	protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PatientListExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    public Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRecidIsNull() {
            addCriterion("RecID is null");
            return (Criteria) this;
        }

        public Criteria andRecidIsNotNull() {
            addCriterion("RecID is not null");
            return (Criteria) this;
        }

        public Criteria andRecidEqualTo(Long value) {
            addCriterion("RecID =", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotEqualTo(Long value) {
            addCriterion("RecID <>", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThan(Long value) {
            addCriterion("RecID >", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidGreaterThanOrEqualTo(Long value) {
            addCriterion("RecID >=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThan(Long value) {
            addCriterion("RecID <", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidLessThanOrEqualTo(Long value) {
            addCriterion("RecID <=", value, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidIn(List<Long> values) {
            addCriterion("RecID in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotIn(List<Long> values) {
            addCriterion("RecID not in", values, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidBetween(Long value1, Long value2) {
            addCriterion("RecID between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andRecidNotBetween(Long value1, Long value2) {
            addCriterion("RecID not between", value1, value2, "recid");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNull() {
            addCriterion("systemID is null");
            return (Criteria) this;
        }

        public Criteria andSystemidIsNotNull() {
            addCriterion("systemID is not null");
            return (Criteria) this;
        }

        public Criteria andSystemidEqualTo(Integer value) {
            addCriterion("systemID =", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotEqualTo(Integer value) {
            addCriterion("systemID <>", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThan(Integer value) {
            addCriterion("systemID >", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("systemID >=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThan(Integer value) {
            addCriterion("systemID <", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidLessThanOrEqualTo(Integer value) {
            addCriterion("systemID <=", value, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidIn(List<Integer> values) {
            addCriterion("systemID in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotIn(List<Integer> values) {
            addCriterion("systemID not in", values, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidBetween(Integer value1, Integer value2) {
            addCriterion("systemID between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andSystemidNotBetween(Integer value1, Integer value2) {
            addCriterion("systemID not between", value1, value2, "systemid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Long value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Long value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Long value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Long value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Long value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Long> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Long> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Long value1, Long value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Long value1, Long value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andPatientidIsNull() {
            addCriterion("PatientID is null");
            return (Criteria) this;
        }

        public Criteria andPatientidIsNotNull() {
            addCriterion("PatientID is not null");
            return (Criteria) this;
        }

        public Criteria andPatientidEqualTo(Long value) {
            addCriterion("PatientID =", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidNotEqualTo(Long value) {
            addCriterion("PatientID <>", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidGreaterThan(Long value) {
            addCriterion("PatientID >", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidGreaterThanOrEqualTo(Long value) {
            addCriterion("PatientID >=", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidLessThan(Long value) {
            addCriterion("PatientID <", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidLessThanOrEqualTo(Long value) {
            addCriterion("PatientID <=", value, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidIn(List<Long> values) {
            addCriterion("PatientID in", values, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidNotIn(List<Long> values) {
            addCriterion("PatientID not in", values, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidBetween(Long value1, Long value2) {
            addCriterion("PatientID between", value1, value2, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientidNotBetween(Long value1, Long value2) {
            addCriterion("PatientID not between", value1, value2, "patientid");
            return (Criteria) this;
        }

        public Criteria andPatientNoIsNull() {
            addCriterion("Patient_NO is null");
            return (Criteria) this;
        }

        public Criteria andPatientNoIsNotNull() {
            addCriterion("Patient_NO is not null");
            return (Criteria) this;
        }

        public Criteria andPatientNoEqualTo(String value) {
            addCriterion("Patient_NO =", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoNotEqualTo(String value) {
            addCriterion("Patient_NO <>", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoGreaterThan(String value) {
            addCriterion("Patient_NO >", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoGreaterThanOrEqualTo(String value) {
            addCriterion("Patient_NO >=", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoLessThan(String value) {
            addCriterion("Patient_NO <", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoLessThanOrEqualTo(String value) {
            addCriterion("Patient_NO <=", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoLike(String value) {
            addCriterion("Patient_NO like", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoNotLike(String value) {
            addCriterion("Patient_NO not like", value, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoIn(List<String> values) {
            addCriterion("Patient_NO in", values, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoNotIn(List<String> values) {
            addCriterion("Patient_NO not in", values, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoBetween(String value1, String value2) {
            addCriterion("Patient_NO between", value1, value2, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientNoNotBetween(String value1, String value2) {
            addCriterion("Patient_NO not between", value1, value2, "patientNo");
            return (Criteria) this;
        }

        public Criteria andPatientAliasIsNull() {
            addCriterion("Patient_ALIAS is null");
            return (Criteria) this;
        }

        public Criteria andPatientAliasIsNotNull() {
            addCriterion("Patient_ALIAS is not null");
            return (Criteria) this;
        }

        public Criteria andPatientAliasEqualTo(String value) {
            addCriterion("Patient_ALIAS =", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasNotEqualTo(String value) {
            addCriterion("Patient_ALIAS <>", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasGreaterThan(String value) {
            addCriterion("Patient_ALIAS >", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasGreaterThanOrEqualTo(String value) {
            addCriterion("Patient_ALIAS >=", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasLessThan(String value) {
            addCriterion("Patient_ALIAS <", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasLessThanOrEqualTo(String value) {
            addCriterion("Patient_ALIAS <=", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasLike(String value) {
            addCriterion("Patient_ALIAS like", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasNotLike(String value) {
            addCriterion("Patient_ALIAS not like", value, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasIn(List<String> values) {
            addCriterion("Patient_ALIAS in", values, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasNotIn(List<String> values) {
            addCriterion("Patient_ALIAS not in", values, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasBetween(String value1, String value2) {
            addCriterion("Patient_ALIAS between", value1, value2, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientAliasNotBetween(String value1, String value2) {
            addCriterion("Patient_ALIAS not between", value1, value2, "patientAlias");
            return (Criteria) this;
        }

        public Criteria andPatientNameIsNull() {
            addCriterion("Patient_NAME is null");
            return (Criteria) this;
        }

        public Criteria andPatientNameIsNotNull() {
            addCriterion("Patient_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andPatientNameEqualTo(String value) {
            addCriterion("Patient_NAME =", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotEqualTo(String value) {
            addCriterion("Patient_NAME <>", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameGreaterThan(String value) {
            addCriterion("Patient_NAME >", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameGreaterThanOrEqualTo(String value) {
            addCriterion("Patient_NAME >=", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameLessThan(String value) {
            addCriterion("Patient_NAME <", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameLessThanOrEqualTo(String value) {
            addCriterion("Patient_NAME <=", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameLike(String value) {
            addCriterion("Patient_NAME like", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotLike(String value) {
            addCriterion("Patient_NAME not like", value, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameIn(List<String> values) {
            addCriterion("Patient_NAME in", values, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotIn(List<String> values) {
            addCriterion("Patient_NAME not in", values, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameBetween(String value1, String value2) {
            addCriterion("Patient_NAME between", value1, value2, "patientName");
            return (Criteria) this;
        }

        public Criteria andPatientNameNotBetween(String value1, String value2) {
            addCriterion("Patient_NAME not between", value1, value2, "patientName");
            return (Criteria) this;
        }

        public Criteria andIdentityidIsNull() {
            addCriterion("identityID is null");
            return (Criteria) this;
        }

        public Criteria andIdentityidIsNotNull() {
            addCriterion("identityID is not null");
            return (Criteria) this;
        }

        public Criteria andIdentityidEqualTo(String value) {
            addCriterion("identityID =", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidNotEqualTo(String value) {
            addCriterion("identityID <>", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidGreaterThan(String value) {
            addCriterion("identityID >", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidGreaterThanOrEqualTo(String value) {
            addCriterion("identityID >=", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidLessThan(String value) {
            addCriterion("identityID <", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidLessThanOrEqualTo(String value) {
            addCriterion("identityID <=", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidLike(String value) {
            addCriterion("identityID like", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidNotLike(String value) {
            addCriterion("identityID not like", value, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidIn(List<String> values) {
            addCriterion("identityID in", values, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidNotIn(List<String> values) {
            addCriterion("identityID not in", values, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidBetween(String value1, String value2) {
            addCriterion("identityID between", value1, value2, "identityid");
            return (Criteria) this;
        }

        public Criteria andIdentityidNotBetween(String value1, String value2) {
            addCriterion("identityID not between", value1, value2, "identityid");
            return (Criteria) this;
        }

        public Criteria andRunFlagIsNull() {
            addCriterion("run_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andRunFlagIsNotNull() {
            addCriterion("run_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andRunFlagEqualTo(Short value) {
            addCriterion("run_FLAG =", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotEqualTo(Short value) {
            addCriterion("run_FLAG <>", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagGreaterThan(Short value) {
            addCriterion("run_FLAG >", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("run_FLAG >=", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagLessThan(Short value) {
            addCriterion("run_FLAG <", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagLessThanOrEqualTo(Short value) {
            addCriterion("run_FLAG <=", value, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagIn(List<Short> values) {
            addCriterion("run_FLAG in", values, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotIn(List<Short> values) {
            addCriterion("run_FLAG not in", values, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagBetween(Short value1, Short value2) {
            addCriterion("run_FLAG between", value1, value2, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunFlagNotBetween(Short value1, Short value2) {
            addCriterion("run_FLAG not between", value1, value2, "runFlag");
            return (Criteria) this;
        }

        public Criteria andRunstatusidIsNull() {
            addCriterion("runStatusID is null");
            return (Criteria) this;
        }

        public Criteria andRunstatusidIsNotNull() {
            addCriterion("runStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andRunstatusidEqualTo(Short value) {
            addCriterion("runStatusID =", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidNotEqualTo(Short value) {
            addCriterion("runStatusID <>", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidGreaterThan(Short value) {
            addCriterion("runStatusID >", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidGreaterThanOrEqualTo(Short value) {
            addCriterion("runStatusID >=", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidLessThan(Short value) {
            addCriterion("runStatusID <", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidLessThanOrEqualTo(Short value) {
            addCriterion("runStatusID <=", value, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidIn(List<Short> values) {
            addCriterion("runStatusID in", values, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidNotIn(List<Short> values) {
            addCriterion("runStatusID not in", values, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidBetween(Short value1, Short value2) {
            addCriterion("runStatusID between", value1, value2, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunstatusidNotBetween(Short value1, Short value2) {
            addCriterion("runStatusID not between", value1, value2, "runstatusid");
            return (Criteria) this;
        }

        public Criteria andRunStatusIsNull() {
            addCriterion("run_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andRunStatusIsNotNull() {
            addCriterion("run_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andRunStatusEqualTo(String value) {
            addCriterion("run_STATUS =", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotEqualTo(String value) {
            addCriterion("run_STATUS <>", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusGreaterThan(String value) {
            addCriterion("run_STATUS >", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusGreaterThanOrEqualTo(String value) {
            addCriterion("run_STATUS >=", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLessThan(String value) {
            addCriterion("run_STATUS <", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLessThanOrEqualTo(String value) {
            addCriterion("run_STATUS <=", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusLike(String value) {
            addCriterion("run_STATUS like", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotLike(String value) {
            addCriterion("run_STATUS not like", value, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusIn(List<String> values) {
            addCriterion("run_STATUS in", values, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotIn(List<String> values) {
            addCriterion("run_STATUS not in", values, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusBetween(String value1, String value2) {
            addCriterion("run_STATUS between", value1, value2, "runStatus");
            return (Criteria) this;
        }

        public Criteria andRunStatusNotBetween(String value1, String value2) {
            addCriterion("run_STATUS not between", value1, value2, "runStatus");
            return (Criteria) this;
        }

        public Criteria andSearchCodeIsNull() {
            addCriterion("search_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSearchCodeIsNotNull() {
            addCriterion("search_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSearchCodeEqualTo(String value) {
            addCriterion("search_CODE =", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeNotEqualTo(String value) {
            addCriterion("search_CODE <>", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeGreaterThan(String value) {
            addCriterion("search_CODE >", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeGreaterThanOrEqualTo(String value) {
            addCriterion("search_CODE >=", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeLessThan(String value) {
            addCriterion("search_CODE <", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeLessThanOrEqualTo(String value) {
            addCriterion("search_CODE <=", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeLike(String value) {
            addCriterion("search_CODE like", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeNotLike(String value) {
            addCriterion("search_CODE not like", value, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeIn(List<String> values) {
            addCriterion("search_CODE in", values, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeNotIn(List<String> values) {
            addCriterion("search_CODE not in", values, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeBetween(String value1, String value2) {
            addCriterion("search_CODE between", value1, value2, "searchCode");
            return (Criteria) this;
        }

        public Criteria andSearchCodeNotBetween(String value1, String value2) {
            addCriterion("search_CODE not between", value1, value2, "searchCode");
            return (Criteria) this;
        }

        public Criteria andKeywordIsNull() {
            addCriterion("KeyWord is null");
            return (Criteria) this;
        }

        public Criteria andKeywordIsNotNull() {
            addCriterion("KeyWord is not null");
            return (Criteria) this;
        }

        public Criteria andKeywordEqualTo(String value) {
            addCriterion("KeyWord =", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordNotEqualTo(String value) {
            addCriterion("KeyWord <>", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordGreaterThan(String value) {
            addCriterion("KeyWord >", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordGreaterThanOrEqualTo(String value) {
            addCriterion("KeyWord >=", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordLessThan(String value) {
            addCriterion("KeyWord <", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordLessThanOrEqualTo(String value) {
            addCriterion("KeyWord <=", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordLike(String value) {
            addCriterion("KeyWord like", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordNotLike(String value) {
            addCriterion("KeyWord not like", value, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordIn(List<String> values) {
            addCriterion("KeyWord in", values, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordNotIn(List<String> values) {
            addCriterion("KeyWord not in", values, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordBetween(String value1, String value2) {
            addCriterion("KeyWord between", value1, value2, "keyword");
            return (Criteria) this;
        }

        public Criteria andKeywordNotBetween(String value1, String value2) {
            addCriterion("KeyWord not between", value1, value2, "keyword");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("SEX is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("SEX is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("SEX =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("SEX <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("SEX >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("SEX >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("SEX <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("SEX <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("SEX like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("SEX not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("SEX in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("SEX not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("SEX between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("SEX not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexidIsNull() {
            addCriterion("SEXid is null");
            return (Criteria) this;
        }

        public Criteria andSexidIsNotNull() {
            addCriterion("SEXid is not null");
            return (Criteria) this;
        }

        public Criteria andSexidEqualTo(Short value) {
            addCriterion("SEXid =", value, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidNotEqualTo(Short value) {
            addCriterion("SEXid <>", value, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidGreaterThan(Short value) {
            addCriterion("SEXid >", value, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidGreaterThanOrEqualTo(Short value) {
            addCriterion("SEXid >=", value, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidLessThan(Short value) {
            addCriterion("SEXid <", value, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidLessThanOrEqualTo(Short value) {
            addCriterion("SEXid <=", value, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidIn(List<Short> values) {
            addCriterion("SEXid in", values, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidNotIn(List<Short> values) {
            addCriterion("SEXid not in", values, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidBetween(Short value1, Short value2) {
            addCriterion("SEXid between", value1, value2, "sexid");
            return (Criteria) this;
        }

        public Criteria andSexidNotBetween(Short value1, Short value2) {
            addCriterion("SEXid not between", value1, value2, "sexid");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateIsNull() {
            addCriterion("Birthday_DATE is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateIsNotNull() {
            addCriterion("Birthday_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateEqualTo(Date value) {
            addCriterion("Birthday_DATE =", value, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateNotEqualTo(Date value) {
            addCriterion("Birthday_DATE <>", value, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateGreaterThan(Date value) {
            addCriterion("Birthday_DATE >", value, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateGreaterThanOrEqualTo(Date value) {
            addCriterion("Birthday_DATE >=", value, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateLessThan(Date value) {
            addCriterion("Birthday_DATE <", value, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateLessThanOrEqualTo(Date value) {
            addCriterion("Birthday_DATE <=", value, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateIn(List<Date> values) {
            addCriterion("Birthday_DATE in", values, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateNotIn(List<Date> values) {
            addCriterion("Birthday_DATE not in", values, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateBetween(Date value1, Date value2) {
            addCriterion("Birthday_DATE between", value1, value2, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andBirthdayDateNotBetween(Date value1, Date value2) {
            addCriterion("Birthday_DATE not between", value1, value2, "birthdayDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIsNull() {
            addCriterion("Register_DATE is null");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIsNotNull() {
            addCriterion("Register_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andRegisterDateEqualTo(Date value) {
            addCriterion("Register_DATE =", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotEqualTo(Date value) {
            addCriterion("Register_DATE <>", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateGreaterThan(Date value) {
            addCriterion("Register_DATE >", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateGreaterThanOrEqualTo(Date value) {
            addCriterion("Register_DATE >=", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLessThan(Date value) {
            addCriterion("Register_DATE <", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateLessThanOrEqualTo(Date value) {
            addCriterion("Register_DATE <=", value, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateIn(List<Date> values) {
            addCriterion("Register_DATE in", values, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotIn(List<Date> values) {
            addCriterion("Register_DATE not in", values, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateBetween(Date value1, Date value2) {
            addCriterion("Register_DATE between", value1, value2, "registerDate");
            return (Criteria) this;
        }

        public Criteria andRegisterDateNotBetween(Date value1, Date value2) {
            addCriterion("Register_DATE not between", value1, value2, "registerDate");
            return (Criteria) this;
        }

        public Criteria andPatientDescIsNull() {
            addCriterion("Patient_DESC is null");
            return (Criteria) this;
        }

        public Criteria andPatientDescIsNotNull() {
            addCriterion("Patient_DESC is not null");
            return (Criteria) this;
        }

        public Criteria andPatientDescEqualTo(String value) {
            addCriterion("Patient_DESC =", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescNotEqualTo(String value) {
            addCriterion("Patient_DESC <>", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescGreaterThan(String value) {
            addCriterion("Patient_DESC >", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescGreaterThanOrEqualTo(String value) {
            addCriterion("Patient_DESC >=", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescLessThan(String value) {
            addCriterion("Patient_DESC <", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescLessThanOrEqualTo(String value) {
            addCriterion("Patient_DESC <=", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescLike(String value) {
            addCriterion("Patient_DESC like", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescNotLike(String value) {
            addCriterion("Patient_DESC not like", value, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescIn(List<String> values) {
            addCriterion("Patient_DESC in", values, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescNotIn(List<String> values) {
            addCriterion("Patient_DESC not in", values, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescBetween(String value1, String value2) {
            addCriterion("Patient_DESC between", value1, value2, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andPatientDescNotBetween(String value1, String value2) {
            addCriterion("Patient_DESC not between", value1, value2, "patientDesc");
            return (Criteria) this;
        }

        public Criteria andCityidIsNull() {
            addCriterion("CityID is null");
            return (Criteria) this;
        }

        public Criteria andCityidIsNotNull() {
            addCriterion("CityID is not null");
            return (Criteria) this;
        }

        public Criteria andCityidEqualTo(Integer value) {
            addCriterion("CityID =", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotEqualTo(Integer value) {
            addCriterion("CityID <>", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThan(Integer value) {
            addCriterion("CityID >", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CityID >=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThan(Integer value) {
            addCriterion("CityID <", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThanOrEqualTo(Integer value) {
            addCriterion("CityID <=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidIn(List<Integer> values) {
            addCriterion("CityID in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotIn(List<Integer> values) {
            addCriterion("CityID not in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidBetween(Integer value1, Integer value2) {
            addCriterion("CityID between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotBetween(Integer value1, Integer value2) {
            addCriterion("CityID not between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNull() {
            addCriterion("City_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNotNull() {
            addCriterion("City_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCityNameEqualTo(String value) {
            addCriterion("City_NAME =", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotEqualTo(String value) {
            addCriterion("City_NAME <>", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThan(String value) {
            addCriterion("City_NAME >", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("City_NAME >=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThan(String value) {
            addCriterion("City_NAME <", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThanOrEqualTo(String value) {
            addCriterion("City_NAME <=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLike(String value) {
            addCriterion("City_NAME like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotLike(String value) {
            addCriterion("City_NAME not like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameIn(List<String> values) {
            addCriterion("City_NAME in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotIn(List<String> values) {
            addCriterion("City_NAME not in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameBetween(String value1, String value2) {
            addCriterion("City_NAME between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotBetween(String value1, String value2) {
            addCriterion("City_NAME not between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andDivisionidIsNull() {
            addCriterion("DivisionID is null");
            return (Criteria) this;
        }

        public Criteria andDivisionidIsNotNull() {
            addCriterion("DivisionID is not null");
            return (Criteria) this;
        }

        public Criteria andDivisionidEqualTo(Integer value) {
            addCriterion("DivisionID =", value, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidNotEqualTo(Integer value) {
            addCriterion("DivisionID <>", value, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidGreaterThan(Integer value) {
            addCriterion("DivisionID >", value, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidGreaterThanOrEqualTo(Integer value) {
            addCriterion("DivisionID >=", value, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidLessThan(Integer value) {
            addCriterion("DivisionID <", value, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidLessThanOrEqualTo(Integer value) {
            addCriterion("DivisionID <=", value, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidIn(List<Integer> values) {
            addCriterion("DivisionID in", values, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidNotIn(List<Integer> values) {
            addCriterion("DivisionID not in", values, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidBetween(Integer value1, Integer value2) {
            addCriterion("DivisionID between", value1, value2, "divisionid");
            return (Criteria) this;
        }

        public Criteria andDivisionidNotBetween(Integer value1, Integer value2) {
            addCriterion("DivisionID not between", value1, value2, "divisionid");
            return (Criteria) this;
        }

        public Criteria andTypeidIsNull() {
            addCriterion("TypeID is null");
            return (Criteria) this;
        }

        public Criteria andTypeidIsNotNull() {
            addCriterion("TypeID is not null");
            return (Criteria) this;
        }

        public Criteria andTypeidEqualTo(Integer value) {
            addCriterion("TypeID =", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidNotEqualTo(Integer value) {
            addCriterion("TypeID <>", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidGreaterThan(Integer value) {
            addCriterion("TypeID >", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("TypeID >=", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidLessThan(Integer value) {
            addCriterion("TypeID <", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidLessThanOrEqualTo(Integer value) {
            addCriterion("TypeID <=", value, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidIn(List<Integer> values) {
            addCriterion("TypeID in", values, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidNotIn(List<Integer> values) {
            addCriterion("TypeID not in", values, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidBetween(Integer value1, Integer value2) {
            addCriterion("TypeID between", value1, value2, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("TypeID not between", value1, value2, "typeid");
            return (Criteria) this;
        }

        public Criteria andTypeNameIsNull() {
            addCriterion("Type_NAME is null");
            return (Criteria) this;
        }

        public Criteria andTypeNameIsNotNull() {
            addCriterion("Type_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andTypeNameEqualTo(String value) {
            addCriterion("Type_NAME =", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotEqualTo(String value) {
            addCriterion("Type_NAME <>", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameGreaterThan(String value) {
            addCriterion("Type_NAME >", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("Type_NAME >=", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameLessThan(String value) {
            addCriterion("Type_NAME <", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameLessThanOrEqualTo(String value) {
            addCriterion("Type_NAME <=", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameLike(String value) {
            addCriterion("Type_NAME like", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotLike(String value) {
            addCriterion("Type_NAME not like", value, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameIn(List<String> values) {
            addCriterion("Type_NAME in", values, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotIn(List<String> values) {
            addCriterion("Type_NAME not in", values, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameBetween(String value1, String value2) {
            addCriterion("Type_NAME between", value1, value2, "typeName");
            return (Criteria) this;
        }

        public Criteria andTypeNameNotBetween(String value1, String value2) {
            addCriterion("Type_NAME not between", value1, value2, "typeName");
            return (Criteria) this;
        }

        public Criteria andRoleidIsNull() {
            addCriterion("RoleID is null");
            return (Criteria) this;
        }

        public Criteria andRoleidIsNotNull() {
            addCriterion("RoleID is not null");
            return (Criteria) this;
        }

        public Criteria andRoleidEqualTo(Integer value) {
            addCriterion("RoleID =", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidNotEqualTo(Integer value) {
            addCriterion("RoleID <>", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidGreaterThan(Integer value) {
            addCriterion("RoleID >", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidGreaterThanOrEqualTo(Integer value) {
            addCriterion("RoleID >=", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidLessThan(Integer value) {
            addCriterion("RoleID <", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidLessThanOrEqualTo(Integer value) {
            addCriterion("RoleID <=", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidIn(List<Integer> values) {
            addCriterion("RoleID in", values, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidNotIn(List<Integer> values) {
            addCriterion("RoleID not in", values, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidBetween(Integer value1, Integer value2) {
            addCriterion("RoleID between", value1, value2, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidNotBetween(Integer value1, Integer value2) {
            addCriterion("RoleID not between", value1, value2, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleNameIsNull() {
            addCriterion("Role_NAME is null");
            return (Criteria) this;
        }

        public Criteria andRoleNameIsNotNull() {
            addCriterion("Role_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andRoleNameEqualTo(String value) {
            addCriterion("Role_NAME =", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameNotEqualTo(String value) {
            addCriterion("Role_NAME <>", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameGreaterThan(String value) {
            addCriterion("Role_NAME >", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameGreaterThanOrEqualTo(String value) {
            addCriterion("Role_NAME >=", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameLessThan(String value) {
            addCriterion("Role_NAME <", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameLessThanOrEqualTo(String value) {
            addCriterion("Role_NAME <=", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameLike(String value) {
            addCriterion("Role_NAME like", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameNotLike(String value) {
            addCriterion("Role_NAME not like", value, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameIn(List<String> values) {
            addCriterion("Role_NAME in", values, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameNotIn(List<String> values) {
            addCriterion("Role_NAME not in", values, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameBetween(String value1, String value2) {
            addCriterion("Role_NAME between", value1, value2, "roleName");
            return (Criteria) this;
        }

        public Criteria andRoleNameNotBetween(String value1, String value2) {
            addCriterion("Role_NAME not between", value1, value2, "roleName");
            return (Criteria) this;
        }

        public Criteria andIconUrlIsNull() {
            addCriterion("icon_URL is null");
            return (Criteria) this;
        }

        public Criteria andIconUrlIsNotNull() {
            addCriterion("icon_URL is not null");
            return (Criteria) this;
        }

        public Criteria andIconUrlEqualTo(String value) {
            addCriterion("icon_URL =", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlNotEqualTo(String value) {
            addCriterion("icon_URL <>", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlGreaterThan(String value) {
            addCriterion("icon_URL >", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlGreaterThanOrEqualTo(String value) {
            addCriterion("icon_URL >=", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlLessThan(String value) {
            addCriterion("icon_URL <", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlLessThanOrEqualTo(String value) {
            addCriterion("icon_URL <=", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlLike(String value) {
            addCriterion("icon_URL like", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlNotLike(String value) {
            addCriterion("icon_URL not like", value, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlIn(List<String> values) {
            addCriterion("icon_URL in", values, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlNotIn(List<String> values) {
            addCriterion("icon_URL not in", values, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlBetween(String value1, String value2) {
            addCriterion("icon_URL between", value1, value2, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andIconUrlNotBetween(String value1, String value2) {
            addCriterion("icon_URL not between", value1, value2, "iconUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlIsNull() {
            addCriterion("list_Picture_Image_URL is null");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlIsNotNull() {
            addCriterion("list_Picture_Image_URL is not null");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlEqualTo(String value) {
            addCriterion("list_Picture_Image_URL =", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlNotEqualTo(String value) {
            addCriterion("list_Picture_Image_URL <>", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlGreaterThan(String value) {
            addCriterion("list_Picture_Image_URL >", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlGreaterThanOrEqualTo(String value) {
            addCriterion("list_Picture_Image_URL >=", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlLessThan(String value) {
            addCriterion("list_Picture_Image_URL <", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlLessThanOrEqualTo(String value) {
            addCriterion("list_Picture_Image_URL <=", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlLike(String value) {
            addCriterion("list_Picture_Image_URL like", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlNotLike(String value) {
            addCriterion("list_Picture_Image_URL not like", value, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlIn(List<String> values) {
            addCriterion("list_Picture_Image_URL in", values, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlNotIn(List<String> values) {
            addCriterion("list_Picture_Image_URL not in", values, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlBetween(String value1, String value2) {
            addCriterion("list_Picture_Image_URL between", value1, value2, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andListPictureImageUrlNotBetween(String value1, String value2) {
            addCriterion("list_Picture_Image_URL not between", value1, value2, "listPictureImageUrl");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIsNull() {
            addCriterion("is_Used_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIsNotNull() {
            addCriterion("is_Used_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagEqualTo(Short value) {
            addCriterion("is_Used_FLAG =", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotEqualTo(Short value) {
            addCriterion("is_Used_FLAG <>", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagGreaterThan(Short value) {
            addCriterion("is_Used_FLAG >", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagGreaterThanOrEqualTo(Short value) {
            addCriterion("is_Used_FLAG >=", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagLessThan(Short value) {
            addCriterion("is_Used_FLAG <", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagLessThanOrEqualTo(Short value) {
            addCriterion("is_Used_FLAG <=", value, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagIn(List<Short> values) {
            addCriterion("is_Used_FLAG in", values, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotIn(List<Short> values) {
            addCriterion("is_Used_FLAG not in", values, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagBetween(Short value1, Short value2) {
            addCriterion("is_Used_FLAG between", value1, value2, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andIsUsedFlagNotBetween(Short value1, Short value2) {
            addCriterion("is_Used_FLAG not between", value1, value2, "isUsedFlag");
            return (Criteria) this;
        }

        public Criteria andCommentIsNull() {
            addCriterion("comment is null");
            return (Criteria) this;
        }

        public Criteria andCommentIsNotNull() {
            addCriterion("comment is not null");
            return (Criteria) this;
        }

        public Criteria andCommentEqualTo(String value) {
            addCriterion("comment =", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotEqualTo(String value) {
            addCriterion("comment <>", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThan(String value) {
            addCriterion("comment >", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentGreaterThanOrEqualTo(String value) {
            addCriterion("comment >=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThan(String value) {
            addCriterion("comment <", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLessThanOrEqualTo(String value) {
            addCriterion("comment <=", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentLike(String value) {
            addCriterion("comment like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotLike(String value) {
            addCriterion("comment not like", value, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentIn(List<String> values) {
            addCriterion("comment in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotIn(List<String> values) {
            addCriterion("comment not in", values, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentBetween(String value1, String value2) {
            addCriterion("comment between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCommentNotBetween(String value1, String value2) {
            addCriterion("comment not between", value1, value2, "comment");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNull() {
            addCriterion("update_UserID is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIsNotNull() {
            addCriterion("update_UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridEqualTo(Long value) {
            addCriterion("update_UserID =", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotEqualTo(Long value) {
            addCriterion("update_UserID <>", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThan(Long value) {
            addCriterion("update_UserID >", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridGreaterThanOrEqualTo(Long value) {
            addCriterion("update_UserID >=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThan(Long value) {
            addCriterion("update_UserID <", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridLessThanOrEqualTo(Long value) {
            addCriterion("update_UserID <=", value, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridIn(List<Long> values) {
            addCriterion("update_UserID in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotIn(List<Long> values) {
            addCriterion("update_UserID not in", values, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridBetween(Long value1, Long value2) {
            addCriterion("update_UserID between", value1, value2, "updateUserid");
            return (Criteria) this;
        }

        public Criteria andUpdateUseridNotBetween(Long value1, Long value2) {
            addCriterion("update_UserID not between", value1, value2, "updateUserid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}